﻿CREATE TABLE [dbo].[codeOutboundStatus] (
    [Status]               INT          IDENTITY (1, 1) NOT NULL,
    [Description]          VARCHAR (50) NOT NULL,
    [AcceptsNextCallTime]  CHAR (1)     NULL,
    [RequiresNextCallTime] CHAR (1)     NULL,
    [RequiresNote]         CHAR (1)     NULL,
    [ReturnToQueue]        CHAR (1)     NULL,
    [Active]               BIT          NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Defines the outbound campaign status and their attributes.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Numeric status code.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'Status';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Definition for status code.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'Description';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Indicates whether the particular status allows NextCallTime as a valid entry (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'AcceptsNextCallTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Indicates whether the status requires a follow up call time to be scheduled (1), or not.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'RequiresNextCallTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Indicates whether the status requires a note to be entered for the campaign record (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'RequiresNote';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Specifies whether the campaign record should be returned to the queue for future contact (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'ReturnToQueue';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Specifies whether the status is  active (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codeOutboundStatus', @level2type = N'COLUMN', @level2name = N'Active';

